ALLU DIWAKAR
21BCE9213
diwakar.21bce9213@vitapstudent.ac.in
1. Upload the dataset to MySQL and integrate with Tableau, delete the unnecessary columns,
explore and visualize the dataset using Tableau.
• Title:
Exploratory Data Analysis and Visualization of Supermarket Sales Data with MySQL and
Tableau.
• Abstract:
This project involves the integration of a historical sales dataset from a supermarket into
MySQL and the subsequent exploration and visualization of the data using Tableau. The
dataset contains various attributes related to sales transactions, such as branch information,
customer type, product categories, prices, and more. Unnecessary columns will be removed
to streamline the dataset. Through Tableau, we will create insightful visualizations to gain a
comprehensive understanding of the sales trends and customer behaviour within the
supermarket.
• Materials and methods:
- Dataset Selection: A historical sales dataset from a supermarket is chosen for analysis.
- MySQL Integration: The dataset is uploaded and integrated into a MySQL database.
- Column Selection: Unnecessary columns are identified and removed to optimize the dataset.
- Tableau Integration: MySQL is connected to Tableau for data visualization.
- Data Exploration: Exploratory data analysis techniques are applied to understand the
dataset.
- Visualization: Various visualizations are created using Tableau to gain insights into sales
trends and customer behaviour.